06/01/2019

Introduction

Construire un mini-entrepôt de données environnementales au format i2b2

Description des données :

##      nom            codeCommune         nomCommune       
##  Length:9572        Length:9572        Length:9572       
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##       cp            designationAPE     designationEPRTR  
##  Length:9572        Length:9572        Length:9572       
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character

Liste des Etablissements polluants selon GeoRisque

localisation etablissement

##  Identifiant        Nom Etablissement  Numéro Siret      
##  Length:14954       Length:14954       Length:14954      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##    Adresse          Code Postal          Commune         
##  Length:14954       Length:14954       Length:14954      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##  Departement           Region          coordonnées_x     
##  Length:14954       Length:14954       Length:14954      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##  coordonnées_y        Code APE         Libellé APE       
##  Length:14954       Length:14954       Length:14954      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##   Code Eprtr        Libelle Eprtr      coordonnees       
##  Length:14954       Length:14954       Length:14954      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character

Liste des Etablissements avec leur localisation

potentiel Radon

##    nom_comm           nom_dept          insee_com         classe_potentiel
##  Length:36104       Length:36104       Length:36104       Min.   :1.000   
##  Class :character   Class :character   Class :character   1st Qu.:1.000   
##  Mode  :character   Mode  :character   Mode  :character   Median :1.000   
##                                                           Mean   :1.449   
##                                                           3rd Qu.:2.000   
##                                                           Max.   :3.000   
##                                                           NA's   :2       
##      reg           
##  Length:36104      
##  Class :character  
##  Mode  :character  
##                    
##                    
##                    
## 

Potentiel Radon

Schema Etoile

Schema Etoile

Schema Etoile

** Schema Etoile **

Tables Construites

##    nom_comm           nom_dept          insee_com         classe_potentiel
##  Length:10429       Length:10429       Length:10429       Min.   :1.000   
##  Class :character   Class :character   Class :character   1st Qu.:1.000   
##  Mode  :character   Mode  :character   Mode  :character   Median :1.000   
##                                                           Mean   :1.515   
##                                                           3rd Qu.:2.000   
##                                                           Max.   :3.000   
##                                                           NA's   :513     
##      reg            Nom_etablissement  Identifiant       
##  Length:10429       Length:10429       Length:10429      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##                                                          
##                                                          
##                                                          
##                                                          
##   Num_Siret           Adresse          Code Postal       
##  Length:10429       Length:10429       Length:10429      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##                                                          
##                                                          
##                                                          
##                                                          
##     Region          coordonnées_x      coordonnées_y     
##  Length:10429       Length:10429       Length:10429      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##                                                          
##                                                          
##                                                          
##                                                          
##    CODE_APE         Libelle_APE         CODE_Eprtr       
##  Length:10429       Length:10429       Length:10429      
##  Class :character   Class :character   Class :character  
##  Mode  :character   Mode  :character   Mode  :character  
##                                                          
##                                                          
##                                                          
##                                                          
##  Libelle Eprtr      coordonnees             lng              lat        
##  Length:10429       Length:10429       Min.   :-12.78   Min.   :-4.927  
##  Class :character   Class :character   1st Qu.: 45.40   1st Qu.: 0.402  
##  Mode  :character   Mode  :character   Median : 47.44   Median : 2.517  
##                                        Mean   : 46.96   Mean   : 2.534  
##                                        3rd Qu.: 48.85   3rd Qu.: 4.839  
##                                        Max.   : 51.05   Max.   :45.257  
## 

** Entrepot de données **

Carte Interactives

Carte Maladie

Carte 1Incidence Maladie par Departement

Carte Potentiel Radon

Carte 2Potentiel Radon par Departement

Carte Etablissements

Carte 3Etablissement Polluants

Analyses de données

Histogramme d'analyse

Histogramme d'analyse

Analyses de données

Test d'autocorrelation Spatial

Voisinage de type QUEEN :

Voisinage de type QUEEN

Test de Morane

## 
##  Moran I test under normality
## 
## data:  ratioEvenement$ratio  
## weights: matrice_conguiteQ    
## 
## Moran I statistic standard deviate = 0.14069, p-value = 0.8881
## alternative hypothesis: two.sided
## sample estimates:
## Moran I statistic       Expectation          Variance 
##      -0.001007117      -0.010526316       0.004578167

Test de Morane

Histogramme du Bootstrap

Histogramme de Bootstrap

Tests de geary

## 
##  Geary C test under randomisation
## 
## data:  ratioEvenement$ratio 
## weights: matrice_conguiteQ 
## 
## Geary C statistic standard deviate = -0.58119, p-value = 0.5611
## alternative hypothesis: two.sided
## sample estimates:
## Geary C statistic       Expectation          Variance 
##       1.041589500       1.000000000       0.005120805

Test de Geary

Autocorrelogramme

Autocorrelogramme

Test de Stone :

Exemple pour Paris

## Stone's Test for raised incidence around locations 
## 
##  Type of boots.: parametric 
##  Model used when sampling: Poisson 
##  Number of simulations: 99 
##  Statistic:  1 
##  p-value :  1

Test de Stone

## PhantomJS not found. You can install it with webshot::install_phantomjs(). If it is installed, please make sure the phantomjs executable can be found via the PATH variable.
Shiny applications not supported in static R Markdown documents

Merci

Merci de votre Attention